PostGIS-T: towards a spatiotemporal PostgreSQL database extension
نویسندگان
چکیده
The temporal dimension of spatial data has been the subject of discussion in the literature for a long time. While there are numerous Database Management System (DBMS) solutions only for spatial dimension, we did not observe the same situation for spatiotemporal data. Considering this gap, our purpose is to design and implement an extension to the DBMS PostgreSQL that is based on a formal spatiotemporal algebra in order to incorporate representations of spatiotemporal data within the DBMS. The proposed extension can be used in a large range of applications. We intend that this extension be a reasonable framework to store and handling observational remote sensing data usually present in applications like animal migration researches, wildfires monitoring, vessel tracking for monitoring fishing, and the like. In this work, we show how to apply it in a case study based on spatiotemporal data collected from drifting buoys belonging to the NOOA’s Global Drifter Program.
منابع مشابه
Working with Spatio-temporal Data Type
Several aspects of spatiotemporal databases have been explored in past decades, ranging from basic data structure to query processing and indexing. But today, operational temporal GIS does not exist. The key impediments have been the complexity of integrating space and time and the lack of standards. OpenGIS standards for simple feature access (spatial type) do exist, but unlike the spatial typ...
متن کاملPostgis Raster Plugin For Quantum GIS
This article describes a graphic tool implementation to upload and visualize raster data stored in a PostgreSQL database with PostGIS extension. The implementation was done as a Quantum GIS plugin called WktRaster, released as an open source software. The plugin is one of the earliest efforts to explore raster data storage, visualization and processing using the PostGIS Raster extension in a Ge...
متن کاملMining Topological Relationship Patterns from Spatiotemporal Databases
Mining topological relationship patterns involve three aspects. First one is the discovery of geometric relationships like disjoint, cover, intersection and overlap between every pair of spatiotemporal objects. Second one is tracking the change of such relationships with time from spatiotemporal databases. Third one is mining the topological relationship patterns. Spatiotemporal databases deal ...
متن کاملDevelopment of a Java client to support
2 Acknowledgements I would like to thank my supervisor Patrick Browne for his help and support with this project. A special thank you to my family without whose support and encouragement this endeavour would not have been possible. Abstract The theme of this report is the development of two graphical clients using the Java programming language. The first supports the native geometric data types...
متن کامل3D Geo-database Implementation using Craniofacial Geometric Morphometrics Database System
Craniofacial Database System has been developed for storing, manipulation and analysis with Geometric Morphometrics concept. The main objective of the system is to store the normal craniofacial (face and/or skull) of Malaysian people. The ‘normal’ is used for reference in many areas such as surgical planning, forensic, gear protective design, and anthropology researches. The data with which we ...
متن کامل